USE [CTEM-DB-v1]
GO

/****** Object:  StoredProcedure [dbo].[DayWorking_Update]    Script Date: 02/10/2012 11:28:51 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		Hainh	
-- Create date: 31/12/2011

-- =============================================
CREATE PROCEDURE [dbo].[DayWorking_Update]
			@DayWorkingID               BIGINT,
			@value                    FLOAT,
			@Date                     DATETIME,
			@WorkerID                 BIGINT
				
AS
BEGIN
	UPDATE  DayWorking 
	SET     Date = @Date,
			Value =@value,
			WorkerID = @WorkerID
	WHERE   DayWorkingID = @DayWorkingID		
END

GO

